-- 顺引工程增加出发延迟台数字段
alter table LA_MaterialDirection add TriggerDelayCount int null
go

-- 更新为 对应 拉绳等的出发延迟台数
UPDATE LA_MaterialDirection
SET LA_MaterialDirection.TriggerDelayCount = LA_SignalLampDirection.TriggerDelayCount
FROM LA_MaterialDirection
left JOIN LA_SignalLampDirection
ON LA_MaterialDirection.MaterialName = LA_SignalLampDirection.SignalMark

-- 把出发链的大物分组删除
update LA_DirectQuoteSetting set IsPhantom=1,IsUse=0 where DirectName='大物' and Type='CFL'